Previous Topic

Next Topic

SQL Reserved Words

Do not use iMIS Table and Field Names or the following SQL Reserved words for custom table and field names. Using iMIS or SQL names may overwrite existing tables and fields. Refer to the release documentation for the latest Alpha Table Layouts.

ABSOLUTE, ACTION, ACTIVE, ACTOR, ADD, AFTER, ALIAS, ALL, ALLOCATE, ALTER, AND, ANY, ARE, AS, ASC, ASCENDING, ASSERTION, ASYNC, AT, ATTRIBUTES, AUTO, AUTOINC, AVG, BASE_NAME, BEFORE, BEGIN, BETWEEN, BINARY, BIT, BIT_LENGTH, BLOB, BOOLEAN, BOTH, BREADTH, BREAK, BY, BYTES, CACHE, CALL, CASCADE, CASCADED, CASE, CAST, CATALOG, CHAR, CHAR_CONVERT, CHAR_LENGTH, CHARACTER, CHARACTER_LENGTH, CHECK, CHECK_POINT_LENGTH, CHECKPOINT, CLOSE, COALESCE, COLLATE, COLLATION, COLUMN, COMMENT, COMMIT, COMMITTED, COMPLETION, COMPUTED, CONDITIONAL, CONNECT, CONNECTION, CONSTRAINT, CONSTRAINTS, CONTAINING, CONTINUE, CONVERT, CORRESPONDING, COUNT, CREATE, CROSS, CSTRING, CURRENT, CURRENT_DATE, CURRENT_PATH, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR, CYCLE, CYCLE DATA, DATA, DATABASE, DATE, DAY, DBA, DBSPACE, DEALLOCATE, DEBUG, DEC, DECIMAL, DECLARE, DEFAULT, DEFERRABLE, DEFERRED, DELETE, DEPTH, DESC, DESCENDING, DESCRIBE, DESCRIPTOR, DESTROY, DIAGNOSTICS, DICTIONARY, DISCONNECT, DISTINCT, DO, DOMAIN, DOUBLE, DROP, EACH, ELEMENT, ELSE, ELSEIF, ENCRYPTED, END, END-EXEC, ENDIF, ENTRY_POINT, EQUALS, ESCAPE, EXCEPT, EXCEPTION, EXEC, EXECUTE, EXISTS, EXIT, EXTERNAL, EXTRACT, FACTOR, FALSE, FETCH, FILE, FILTER, FIRST, FLOAT, FOR, FOREIGN, FROM, FULL, FUNCTION, GDSCODE, GEN_ID, GENERAL, GENERATOR, GET, GLOBAL , GOTO, GRANT, GROUP, GROUP_COMMIT_WAIT_TIME, HAVING, HOLD, HOLDLOCK, HOUR, IDENTIFIED, IDENTITY, IF, IGNORE, IMMEDIATE, IN, INACTIVE, INDEX, INITIALLY, INNER, INOUT, INPUT, INPUT_TYPE, INSENSITIVE, INSERT, INSTEAD, INT, INTEGER, INTERSECT, INTERVAL, INTO, IS, ISOLATION, JOIN, KEY, LAST, LEADING, LEAVE, LEFT, LENGTH, LESS, LEVEL, LIKE, LIMIT, LIST, LOCAL, LOCK, LOG_BUFFER_SIZE, LOGFILE, LONG, LOOP, LOWER, MANUAL, MATCH, MAX, MAXIMUM_SEGMENT, MEMBERSHIP, MERGE, MESSAGE, MIN, MINUTE, MODIFY, MODULE_NAME, MONEY, MONTH, NAMED, NAMES, NATIONAL, NATURAL, NCHAR, NEW_TABLE, NEXT, NO, NOHOLDLOCK, NONE, NOT, NULL, NULLIF, NUM_LOG_BUFFERS, NUMERIC, OBJECT, OCTET_LENGTH, OF, OFF, OID, OLD, OLD_TABLE, ON, ONLY, OPEN, OPERATION, OPERATOR, OPERATORS, OPTION, OPTIONS, OR, ORDER, OTHERS , OUT, OUTER, OUTPUT, OUTPUT_TYPE, OVERFLOW, OVERLAPS, PAD, PAGE PAGES, PAGE_SIZE, PARAMETER, PARAMETERS, PARTIAL, PASSTHROUGH, PASSWORD, PATH, PENDANT, PLAN, POSITION, POST_EVENT, POSTFIX, PRECISION, PREFIX, PREORDER, PREPARE, PRESERVE, PRIMARY, PRINT, PRIOR, PRIVATE, PRIVILEGES, PROC, PROCEDURE, PROTECTED, RAISERROR, RAW_PARTITIONS, RDB$DB_KEY, READ, READTEXT, REAL, RECORD_VERSION, RECURSIVE, REF, REFERENCE, REFERENCES, REFERENCING, RELATIVE, RELEASE, REMOTE, RENAME, REPLACE, RESERV, RESERVING, RESIGNAL, RESOURCE, RESTRICT, RETAIN, RETURN, RETURNING_VALUES, RETURNS, REVOKE, RIGHT, ROLE, ROLLBACK, ROUTINE, ROW, ROWS, SAVE, SAVEPOINT, SCHEDULE, SCHEMA, SCROLL, SEARCH, SECOND, SEGMENT, SELECT, SENSITIVE, SEQUENCE, SESSION, SESSION_USER, SET, SHADOW, SHARE, SHARED, SIGNAL, SIMILAR, SINGULAR, SIZE, SMALLINT, SNAPSHOT, SOME, SORT, SPACE, SQLCODE, SQLEXCEPTION, SQLSTATE, SQLWARNING, STABILITY, START, STARTING, STARTS, STATE, STATISTICS, STOP, STRUCTURE, SUB_TYPE, SUBSTRING, SUBTRANS, SUBTRANSACTION, SUM, SUSPEND, SYMBOL, SYNCHRONIZE, SYNTAX_ERROR, SYSTEM_USER, TABLE, TEMPORARY, TERM, TEST, THEN, THERE, TIME, TIMESTAMP, TIMEZONE_HOUR, TIMEZONE_MINUTE, TINYINT, TO, TRAILING, TRAN, TRANSACTION, TRANSLATE, TRANSLATION, TRIGGER, TRIM, TRUE, TRUNCATE, TSEQUAL, TUPLE, TYPE, UNCOMMITTED, UNDER, UNION, UNIQUE, UNKNOWN, UPDATE, UPPER, USAGE, USER, USING, VALIDATE, VALUE, VALUES, VARBINARY, VARCHAR, VARIABLE, VARYING, VIEW, VIRTUAL, VISIBLE, WAIT, WHEN, WHERE, WHILE, WITH, WITHOUT, WORK, WRITE, WRITETEXT, YEAR, ZONE ACTION

See Also

iMIS Customizer

Overview of iMIS Customizer

Creating a Custom Table

Creating a Custom Tab

Reviewing the Customizer interface

Entering User-Defined (Custom) Data

Viewing Data on Multiple-Instance, User-Defined Tabs in a Non-Grid Format

Viewing Read-Only Fields in User-Defined Windows

Converting Existing Fields

Limiting Access and/or Hiding Custom Window Tabs

Customizer Tips

Customizer Troubleshooting


ASI logo 10.6 Production Release. Updated 7/1/2005 2:21:46 PM
Copyright © by Advanced Solutions International, Inc. All rights reserved.